package at.ac.tuwien.sepm.s2011.e0208329.dao;
import java.util.List;
import at.ac.tuwien.sepm.s2011.e0208329.domain.Item;

public interface ItemDao {
	
	public void insert(Item item) throws Exception; // add Item to db

	public void updateStorage(int nr,int str) throws Exception; // change the Storage of a Item
	                                                     // with referred Nr
	public void updatePrice(int nr,int pr) throws Exception; //change the Price of a Item
	                                                  // with referred Nr
	public void delete(int nr) throws Exception; //Delete Item with referred Nr
	
	public List<Item> queryAll() throws Exception ;// Get all Items in DB
	
	public List<Item> queryBy(String name,String type,int uppr,
			int lowpr) throws Exception ;//Combi-Search(Name+Type+Price) 
	                                              //for available Items
	                                              
 		
}
